Price/Cost Mass Updates - FIL 37
Example of Raising List Price by a Percentage of Itself
Example of Changing List Price to a Percentage of Base Cost
You can use the Price/Cost Mass Updates Program to change prices or costs in multiple records with a single entry. It can raise or lower costs and prices by a percentage of existing prices and costs. For example, you can update your list prices to be a percentage above your standard cost, or simply raise prices or costs by a percentage. The program can run in test mode or update mode.
When entering selection criteria, multiple categories are processed in an AND relationship, and multiple entries in the same category are processed in an OR relationship. For example, if you enter two manufacturers, ABC and XYZ, and two Wear codes, C and D, the program selects items that are coded for manufacturers ABC or XYZ, and have Wear codes C or D. We recommend that you use the test mode feature of this program until you fully understand how to enter selection criteria correctly.
|
Field Name |
Description/Instructions |
|
MFGR |
Manufacturer codes, which are the first three characters of the item number. |
|
PROD LINE |
Product lines codes, as defined in the Product Line File - FIL 12 and entered in the Item File - FIL 2. |
|
ITEM CLASS 1 |
Item Class 1 as defined in the Classification Codes File - FIL 19 and entered in the Item File. |
|
ITEM CLASS 2 |
Item Class 2 as defined in the Classification Codes File and entered in the Item File. |
|
ITEM CLASS 3 |
Item Class 3 as defined in the Classification Codes File and entered in the Item File. |
|
TRIM CLASS |
Trim class code as defined in the Classification Codes File and entered in the Item File. |
|
ITEM POLICY |
Item policy codes as entered in the Item File. |
|
COLOR # |
The four characters of the item number that directly follow the manufacturer code. |
|
COLOR NAME |
Color name or description as entered in the Item File. |
|
PATTERN# |
The nine characters of the item number that directly follow the color number. |
|
PATTN NAME |
Pattern name or description as entered in the Item File. |
|
PRICE CLASS |
Price class code as defined in the Price File and entered in the Item File. |
|
COST CLASS |
Cost class code as defined in the Cost File and entered in the Item File. |
|
PACKG CLASS |
The packaging class code as defined in the Packaging File - FIL 11 and entered in the Item File. |
|
SUPPLIER CD |
Enter up to three supplier codes to update the PRICE or COST class files that are related to items of that certain supplier, as opposed to a manufacturer. |
|
INVENT CODE |
Inventory code.
|
|
COMPON CODE |
Component code as entered in the Item File. See Item File for a complete list of component codes. Common codes include S (serial number items) and R (rolled goods). |
|
COMMOD LEVL |
Commodity level code as defined in the Classification Codes File and entered in the Item File. |
|
ABC CODE |
ABC rating code as defined in the ABC Code File -FIL 34 and entered in the Item File. |
|
WEAR CODE |
Wear rating code as defined in the Classification Codes File and entered in the Item File. |
|
COST CENTER |
Cost center (also known as the product division) as defined in the Cost Center File - FIL 24 and entered in the Item File. |
|
FRT CLASS |
Freight classification code as defined in the Classification Codes File and entered in the Item file. |
|
QTY BRK GRP |
Quantity break group code as defined in the Classification Codes File and entered in the Item File. |
|
STRING SEARCH |
Enter any consecutive string of an item number. The program selects any items that have that string of characters in the item number regardless of what position in the item number the string is found. For example, if you enter A39 in the String Search field, the program selects any item whose item number includes A39. Item numbers ABC1001A39 and XZYAA39B9 would both be selected. |
On the Price/Cost Mass Updates Parameter screen. Enter one of the two available charge options, but not both. Specify if you are performing a test, or if the files should be updated.
|
Field Name |
Description/Instructions |
|
Change List Price |
Enter X to update list prices. |
|
Change Standard Base Cost |
Enter X to update standard base costs. |
|
Change Standard Freight Cost |
Enter X to update standard freight costs. |
|
Raise |
Enter X to raise the price or cost field selected above by the percentage specified. |
|
Lower |
Enter X to lower the price or cost field selected above by the percentage specified. |
|
% (of itself) |
Enter the percentage to raise or lower the price or cost field selected. Use a decimal point, if needed. For example, enter 2.75 for 2.75% or 2 or 2.00 for 2%. |
|
Change it to % |
Enter the percentage of the following field to which you want to change the price to cost. |
|
Of List Price |
Enter X to change the selected field to a percentage of the list price. |
|
Of Standard Base Cost |
Enter X to change the above selected field to a percentage of the standard base cost. |
|
Of Standard Freight Cost |
Enter X to change the above selected field to a percentage of the standard freight cost. |
|
Of Standard Last Cost (Landed) |
Enter X to change the above selected field to a percentage of the standard landed (last) cost. Landed cost includes base and freight portions of the cost. |
|
Test |
Enter X to print a report based on the parameters entered, but not updating the files. |
|
Update |
Enter X to perform the mass update based on the parameters entered. A report is printed. |
Example of Raising List Price by a Percentage of Itself
We recommend that you run tests until you are certain of how your entries affect prices or costs. When you run a test, a list price prints showing the before and after version of each affected price. Enter X beside Update to actually update the files.
Example of Changing List Price to a Percentage of Base Cost
This example changes the list price to 110% of the current standard base cost.
Associated Files
Change Price, Cost, or Packaging Codes - SYS 106
Run Future Price & Promo File Update (check effective/ending dates) - SYS 308